`texeport`: JSON export formats

Comprehensive PDF documentation about Texpress can be found here.

Details about exporting, and texeport specifically, can be found here.

The Texpress texforms module supports a general purpose data exporting facility. Five predefined export formats were supported by its texeport program prior to EMu 10:

Comma delimited
Fixed width
Ids
Ids (brief)
Texpress data

From EMu 10 and Texpress 11.0.015 onwards support for JSON as an export format is also available. The -f option, which specifies the output format, supports the following JSON formats:

Format	Details
`json`	Produces a simple JSON output format with only the top level item names. The names used are the `texforms` format (that is without `_tab`, etc.). A JSON value is output for all items in the database, even empty ones. Example For example `texexport -l69 -fjson ecatalogue` in the museum environment will produce: [ { "irn": 69, "SummaryData": "[Technology] \"Tracking system console from Orroral Valley Tracking Station\"[NM.2008.12]", "ExtendedData": "69\n[Technology] Object Accessioned\nTracking system console from Orroral Valley Tracking Station\nNM.2008.12, accessioned on\/in 2008", "ObjectType": "Object", "TitObjectStatus": "Accessioned", "TitObjectRating": "Medium", "TitObjectCategory": "Technology", "TitNumberOfParts": 1, "TitPartNumber": 1, "TitCollectionGroup": [ null, "Collection", null, "Another Collection" ], "TitAccessionNo": "NM.2008.12", "TitAccessionDate": "2008-09-28", "AccAccessionLotRef": 67, "AccAccessionLotRefLocal": 67, "TitPreviousAccessionNo": [], "TitCreditLineLocal": "Source: National Museum of Australia", "TitRegisteredByRef": null, "TitRegistrationDate": null, "TitTransferType": [], "TitTransferFromRef": [], "TitTransferToRef": [], "TitTransferDate0": [], "TitTransferNotes": [], "TitOwnersNameRef": [], "TitOwnersDates": [], "TitOwnersStartDate0": [], "TitOwnersStartDateOrig": [], "TitOwnersEndDate0": [], "TitOwnersEndDateOrig": [], "TitOwnersNotes": [], "CraCrateType": null, "CraOrientation": null, "CraCrateNumber": null, "CraNumberOfSlots": null, "CraTotalNumberOfTrays": null, "CraExternalHeight": null, "CraExternalDepth": null, "CraExternalWidth": null, "CraSlotHeight": null, "CraSlotDepth": null, "CraSlotWidth": null, "CraTrayHeight": [], "CraTrayDepth": [], "CraTrayWidth": [], "CraRemarks": [], "CraObjectsRef": [], "FraType": null, "FraDescription": null, "FraTotalNoOfTrays": null, "FraAssociatedWorkRef": null, "FraAssociatedWorkRefLocal": null, "FraAssociatedWorkLocal": null, "FraExternalHeight": null, "FraExternalWidth": null, "FraExternalDepth": null, "FraInternalHeight": null, "FraInternalWidth": null, "FraInternalDepth": null, "FraGlazing": null, "FraBacking": null, "FraObjectsRef": [], "TitMainTitle": "Tracking system console from Orroral Valley Tracking Station", "TitSeriesTitle": null, "TitCollectionTitle": null, "TitAlternateTitles": [], "TitTitleNotes": null, "CreCreatorRef": [], "CreRole": [], "CreCreatorRefLocal0": [], "CreCreatorLocal": [], "CreCreationPlace1": [ "North America" ], "CreCreationPlace2": [ "United States of America" ], "CreCreationPlace3": [], "CreCreationPlace4": [], "CreCreationPlace5": [], "CreCreationPlaceSummary": [], "CreDateCreated": "1965", "CreEarliestDate": "1965", "CreEarliestDateOrig": 0, "CreLatestDate": "1965", "CreLatestDateOrig": 0, "CreCreationNotes": null, "CreCulturalOrigin1": null, "CreCulturalOrigin2": null, "CreCulturalOrigin3": null, "CreCulturalOrigin4": null, "CreCulturalOrigin5": null, "CreCulturalOriginSummary": null, "CreSubjectClassification": [], "CrePrimaryInscriptions": null, "CreOtherInscriptions": null, "CreProvenance": null, "EdiState": null, "EdiImpression": null, "EdiPublisherRef": null, "EdiEditionNotes": null, "EdiPatternNumber": [], "EdiPatternNumberNotes": [], "EdiBookNumberPages": null, "EdiBookPageNumbers": null, "PhyTechnique": [], "PhyMedium": [], "PhySupport": null, "PhyWatermark": null, "PhyMaterial": [ "Glass", "Metal", "Plastic" ], "PhyContentAnalysis": [], "PhyDescription": "This is the tracking system console from Orroral Valley Tracking Station.\nIt is a grey metal cabinet with a sloping desk section at front, featuring printed sheets bearing original satellite tracking coordinates beneath a perspex sheet. Switches and dials are located at the front for the operation of unit.", "PhyPartPart": [], "PhyPartAspect": [], "PhyPartDescription0": [], "PhyHeight": [ 1095 ], "PhyWidth": [ 1510 ], "PhyDepth": [ 1150 ], "PhyDiameter": [], "PhyUnitLength": [ "mm" ], "PhyWeight": [], "PhyUnitWeight": [], "PhyType": [], "PhyVerbatimMeasurements": null, "AssIsParent": "Yes", "AssParentObjectRef": null, "AssRelatedObjectsRef": [], "AssRelatedObjectsRelationship": [], "AssRelatedObjectsRefLocal0": [], "AssRelatedObjectsLocal": [], "AssOtherAssociationType": [], "AssOtherAssociationNotes0": [], "AssRelatedPartiesRef": [], "AssRelatedPartiesRelationship": [], "AssRelatedEventsRef": [], "AssRelatedEventsRelationship": [], "AssRelatedPlacesLevel1": [], "AssRelatedPlacesLevel2": [], "AssRelatedPlacesLevel3": [], "AssRelatedPlacesLevel4": [], "AssRelatedPlacesLevel5": [], "AssRelatedPlacesRelationship": [], "AssRelatedPlacesSummary": [], "RigRightsRef": [], "RefCatalogueRaisonne": null, "BibBibliographyRef": [], "RefBibliographicNotes": [], "RefImageType": [], "RefImageReference": [], "RefFileTitle": [], "RefFileReference": [], "StaAuthorisedByRef": [], "StaDateAuthorised0": [], "StaReason": [], "StaStocktakeStatus": null, "StaStocktakeDate": null, "StaStocktakeByRef": null, "LocCurrentLocationRef": 1001690, "LocCurrentLocationRefLocal": 1001690, "LocSummaryDataLocal": null, "LocRequestedByRef": 3, "LocReleasedByRef": 23, "LocAcceptedByRef": 23, "LocDateMoved": "2013-09-24", "LocTimeMoved": "11:29:", "LocIndependentlyMoveable": "Yes", "LocMovementNotes": null, "LocPermanentLocationRef": 1000051, "LocTemporaryLocationRef": null, "ConConditionStatus": "Excellent", "ConDateChecked": "2008-09-20", "ConCheckedByRef": 29, "ConNextCheck": "2013-09-20", "ConConditionPeriod": 5, "ConConditionPeriodType": "Years", "ConConditionDetails": null, "ConHandlingInstructions": null, "IllMaximumExposure": null, "IllExposurePeriod": null, "IllExposurePeriodType": null, "IllCumulativeExposure": null, "IllCumulativeStartDate": null, "IllCumulativeEndDate": null, "IllMaxDisplayableDays": null, "IllMaxDailyExposure": null, "IllMaxLuxLevel": null, "ConDispMinHumidity": null, "ConDispMaxHumidity": null, "ConDispGenHumidity": null, "ConDispMinCelTemperature": null, "ConDispMinFarTemperature": null, "ConDispMaxCelTemperature": null, "ConDispMaxFarTemperature": null, "ConDispGenTemperature": null, "ConDispMinLight": null, "ConDispMaxLight": null, "ConDispGenLight": null, "ConDispOtherInstructions": null, "DisExhibitionHistory": null, "ConStorMinHumidity": null, "ConStorMaxHumidity": null, "ConStorGenHumidity": null, "ConStorMinCelTemperature": null, "ConStorMinFarTemperature": null, "ConStorMaxCelTemperature": null, "ConStorMaxFarTemperature": null, "ConStorGenTemperature": null, "ConStorMinLight": null, "ConStorMaxLight": null, "ConStorGenLight": null, "ConStorOtherInstructions": null, "ValValuedByRef": 27, "ValDateValued": "2008-09-14", "ValValuationAmount": null, "ValValuationAmountOrig": null, "ValNextDue": "2012-09-14", "ValReasonForValuation": "Insurance", "ValValuationPeriod": 4, "ValValuationPeriodType": "Years", "ValValuationNotes": null, "InsInsuranceRef": null, "ValDepreciationCategory": null, "ValDepreciationDescription": null, "DeaDeaccessionMethod": null, "DeaAuthorisedByRef": null, "DeaDateAuthorised": null, "DeaMeetingTitle": null, "DeaMeetingDate": null, "DeaDeaccessionDate": null, "DeaDeaccessionNotes": null, "DeaReceivingPartyRef": null, "DeaTransferOfTitle": null, "DeaTransferDate": null, "DeaTransferNotes": null, "ColCollectionsRef": [], "IsArchive": null, "ArchiveSortPosition": null, "AssParentObjectRefLocal": null, "EADParentIdentifierLocal": null, "EADTitleProper": null, "EADSubtitle": null, "EADSponsorRef": null, "EADEditionStatement": null, "EADPublicationStatement": null, "EADNoteStatement": null, "EADCreation": null, "EADLanguageOfFindingAid": null, "EADAuthorOfFindingAidRef": null, "EADLanguageCodeOfFindingAid": null, "EADDescriptiveRules": null, "EADRevisionDate": null, "EADRevision": null, "EADRevisionByRef": null, "EADRepositoryRef": null, "EADIdentifier": null, "EADUnitID": null, "EADComponentLevel": null, "EADLevelAttribute": null, "EADUnitTitle": null, "EADUnitDate": null, "EADUnitDateEarliest": null, "EADUnitDateEarliestOrig": null, "EADUnitDateLatest": null, "EADUnitDateLatestOrig": null, "EADOriginationRef": [], "EADPreviousID": [], "EADPhysicalDescription": [], "EADExtent": [], "EADDimensions": null, "EADGenreForm": [], "EADPhysicalFacet": null, "EADMaterialSpecificDetail": null, "EADAbstract": null, "EADLanguageOfMaterial": [], "EADLanguageCodeOfMaterial": [], "EADBiographyOrHistory": null, "EADCustodialHistory": null, "EADAcquisitionInformationRef": null, "EADScopeAndContent": null, "EADAppraisalInformation": null, "EADAccessRestrictions": null, "EADUseRestrictions": null, "EADOtherFindingAid": null, "EADIndex": null, "EADAccruals": null, "EADArrangement": null, "EADFilePlan": null, "EADPhysicalTechnical": null, "EADProcessingInformation": null, "EADBibliographyRef": [], "EADPreferredCitation": null, "EADOtherDescriptiveData": null, "EADNote": null, "EADLocationOfOriginals": null, "EADAlternativeFormAvailable": null, "EADRelatedMaterial": null, "EADSeparatedMaterial": null, "EADPersonalName": [], "EADFamilyName": [], "EADCorporateName": [], "EADGeographicName": [], "EADOtherName": [], "EADSource": null, "EADName": [], "EADPersonalNameRef": [], "EADFamilyNameRef": [], "EADCorporateNameRef": [], "EADGeographicNameRef": [], "EADSubjectAuthoritative": [], "EADFunction": [], "EADOccupation": [], "EADSubject": [], "EADTitle": [], "AcnAccessionLotRef": [], "AcnLocationRef": [], "AcnOriginalExtent": [], "AcnAssessmentType": [], "AcnAssessmentValue": [], "AcnConservationNeeds": null, "AcnDescription": null, "AcnProcessingPlan": null, "TitAcquisitionMethod": null, "TitFullName": null, "MulMultiMediaRef": [ 555 ], "MulHasMultiMedia": "Y", "MulMultiMediaRefLocal": 555, "MulMediaPublishNoPasswordLocal": "Yes", "NotNotes": null, "AdmGUIDPreferredType": "UUID4", "AdmGUIDPreferredValue": "5ffeb5cd-4edf-410a-9fff-5c6f67dc0056", "AdmGUIDIsPreferred": [ "Yes" ], "AdmGUIDType": [ "UUID4" ], "AdmGUIDValue": [ "5ffeb5cd-4edf-410a-9fff-5c6f67dc0056" ], "AdmInsertedBy": "KE EMu Administrator", "AdmDateInserted": "2012-07-17", "AdmImportIdentifier": null, "AdmTimeInserted": "11:39:20.000", "AdmSystemIdentifier": null, "AdmModifiedBy": "KE EMu Administrator", "AdmDateModified": "2025-08-05", "AdmTimeModified": "19:03:44.000", "AdmWebMetadata": "Tracking system console from Orroral Valley Tracking Station North America United States of America 1965 1965 1965 Glass Metal Plastic This is the tracking system console from Orroral Valley Tracking Station. It is a grey metal cabinet with a sloping desk section at front, featuring printed sheets bearing original satellite tracking coordinates beneath a perspex sheet. Switches and dials are located at the front for the operation of unit.", "AdmPublishWebNoPasswordFlag": "Y", "AdmPublishWebNoPassword": "Yes", "AdmPublishWebPasswordFlag": "Y", "AdmPublishWebPassword": "Yes", "AdmOriginalData": null, "SecRecordStatus": null, "SecWebImportance": null, "SecCanDisplay": [ "Group Default" ], "SecCanEdit": [ "Group Default" ], "SecCanDelete": [ "Group Default" ], "SecDepartment": [], "TasDescription": [], "TasResults": [], "TasPersonAssignedToRef": [], "TasDependOnTask": [], "TasDependOnCompletionOffset": [], "TasTaskDuration": [], "TasCommenceNotifyOffset": [], "TasCompletionNotifyOffset": [], "TasDependOnPosition": [], "TasCommenceNotifyRef": [], "TasCompletionNotifyRef": [], "TasTaskAssignerRef": [], "TasCommencementDate0": [], "TasStartNotifyDate0": [], "TasTimeTakenOnTask": [], "TasCompleted": [], "TasCompletionDate0": [], "TasEndNotifyDate0": [], "TaxTaxonomyRef": [], "IdeIdentifiedByRef": [], "IdeFiledAs": [], "IdeDateIdentified0": [], "IdeIdentificationNotes0": [], "IdeCurrentTaxonRef": null, "IdeCurrentTaxonRefLocal": null, "IdeCurrentScientificNameLocal": null, "IdeCommonNameLocal": null, "IdeCurrentIdentifiedByRef": null, "IdeCurrentIdentifiedByRefLocal": null, "IdeCurrentIdentifiedByLocal": null, "SitPreciseLocation": [], "ColCollectorsRef": [], "ColCollectionNotes": [], "ColCollectionDates0": [], "ColCollectorsRefLocal0": [], "ColCollectorsLocal": [], "ColCollectionType": null, "ColCollectionMethod": null, "ColRecordedUse": null, "AccSourceRef": [ 246 ], "AccSourceRefLocal0": [ 246 ], "AccSourceRoleRef": [], "AccSourceLocal": [ "National Museum of Australia" ], "SpeNumberSpecimens": null, "SpeNumberMale": null, "SpeNumberFemale": null, "SpeAge": null, "SpePhase": null, "SpeForm": null, "SpeVariety": null, "SpeMedium": null, "ColCataloguerRef": [], "SpePreparation": [], "SpePreparedByRef": [], "SpePreparationNotes": [], "ColCataloguerDate0": [], "SpeDatePrepared0": [], "MapTitle": null, "MapAbbreviatedTitle": null, "MapScale": null, "MapAuthorsRef": [], "MapRole": [], "MapEdition": null, "MapVolume": null, "MapPages": null, "MapPublisherRef": null, "MapPublicationDate": null, "MapPublicationCity": null, "MapSeriesTitle": null, "MapSeriesVolumeRange": null, "MapSeriesDateRange": null, "GeoIdentifiedByRef": [], "GeoClass": null, "GeoGroup": null, "GeoName": null, "GeoVariety": null, "GeoChronostratigraphy": null, "GeoLithostratigraphy": null, "ImaNegativeNumber": null, "ImaImageType": null, "ImaImageSize": null, "ImaImageDescription": null, "SitSiteCode": [], "SitProjectName": [], "SitSiteCharacter": [], "SitMonumentType": [], "SitSiteName": [], "SitInterventionRef": [], "SitArchaeoFeatures": null, "SitBulkFindType": [], "SitBulkFindLocationRef": [], "SitBulkFindQuantity": [], "SitBulkFindQuantityType": [], "SitPaperArchiveType": [], "SitPaperArchiveLocationRef": [], "SitPaperArchiveQuantity": [], "SitPaperArchiveQuantityType": [], "SitLegacyArchives": [], "SitLegacyArchivesLocationRef": [], "SitLegacyArchivesQuantity": [], "ClaObjectName": [], "EthLocalName": null, "ColCollectionEventRef": 7, "ColDateCollectedFrom": null, "ColDateCollectedTo": null, "EthLanguageGroup": null, "EthCulturalGroup": null, "EthAssociatedDeity": [], "ColCollectorsRole": [], "ClaLevel1Classification": null, "ClaLevel2Classification": null, "ClaLevel3Classification": null, "ClaLevel4Classification": null, "ClaLevel5Classification": null, "ClaActivityCode": [], "AssAssociationsType": [], "AssAssociationNameRef": [], "AssSiteRef": [], "AssPreciseLocation": [], "AssSiteRefLocal": null, "AssSiteSummaryDataLocal": null, "AssSiteRefLocal0": [], "SiteContinentLocal": [], "SiteCountryLocal": [], "SiteProvinceStateTerritoryLocal": [], "SiteDistrictCountyShireLocal": [], "SiteTownshipLocal": [], "AssAssociationDate": [], "AssAssociationEarliestDateOrig": [], "AssAssociationLatestDateOrig": [], "AssAssociationEarliestDate0": [], "AssAssociationLatestDate0": [], "AssAssociationEvent": [], "AssAssociationPeriod": [], "AssAssociationComments0": [], "NteText0": [], "NteAttributedToRef": [], "NteBibliographyRef": [], "NteDate0": [], "NteType": [], "SecLookupRoot": null, "Validation": null } ]
`jsonbrief`	As for `json` format except empty items are skipped. Example For example `texexport -l69 -fjsonqlbrief ecatalogue` in the museum environment will produce: [ { "irn": { "irn_1": 69 }, "SummaryData": "[Technology] \"Tracking system console from Orroral Valley Tracking Station\" [NM.2008.12]", "ExtendedData": "69\n[Technology] Object Accessioned\nTracking system console from Orroral Valley Tracking Station\nNM.2008.12, accessioned on\/in 2008", "ObjectType": "Object", "TitObjectStatus": "Accessioned", "TitObjectRating": "Medium", "TitObjectCategory": "Technology", "TitNumberOfParts": 1, "TitPartNumber": 1, "TitCollectionGroup_tab": [ { "TitCollectionGroup": null }, { "TitCollectionGroup": "Collection" }, { "TitCollectionGroup": null }, { "TitCollectionGroup": "Another Collection" } ], "TitAccessionNo": "NM.2008.12", "TitAccessionDate": "2008-09-28", "AccAccessionLotRef": 67, "AccAccessionLotRefLocal": { "AccAccessionLotRefLocal_1": 67 }, "TitCreditLineLocal": "Source: National Museum of Australia", "TitMainTitle": "Tracking system console from Orroral Valley Tracking Station", "CreCreationPlace1_tab": [ { "CreCreationPlace1": "North America" } ], "CreCreationPlace2_tab": [ { "CreCreationPlace2": "United States of America" } ], "CreDateCreated": "1965", "CreEarliestDate": "1965", "CreEarliestDateOrig": 0, "CreLatestDate": "1965", "CreLatestDateOrig": 0, "PhyMaterial_tab": [ { "PhyMaterial": "Glass" }, { "PhyMaterial": "Metal" }, { "PhyMaterial": "Plastic" } ], "PhyDescription": "This is the tracking system console from Orroral Valley Tracking Station.\nIt is a grey metal cabinet with a sloping desk section at front, featuring printed sheets bearing original satellite tracking coordinates beneath a perspex sheet. Switches and dials are located at the front for the operation of unit.", "PhyHeight_tab": [ { "PhyHeight": 1095 } ], "PhyWidth_tab": [ { "PhyWidth": 1510 } ], "PhyDepth_tab": [ { "PhyDepth": 1150 } ], "PhyUnitLength_tab": [ { "PhyUnitLength": "mm" } ], "AssIsParent": "Yes", "LocCurrentLocationRef": 1001690, "LocCurrentLocationRefLocal": { "LocCurrentLocationRefLocal_1": 1001690 }, "LocRequestedByRef": 3, "LocReleasedByRef": 23, "LocAcceptedByRef": 23, "LocDateMoved": "2013-09-24", "LocTimeMoved": "11:29:", "LocIndependentlyMoveable": "Yes", "LocPermanentLocationRef": 1000051, "ConConditionStatus": "Excellent", "ConDateChecked": "2008-09-20", "ConCheckedByRef": 29, "ConNextCheck": "2013-09-20", "ConConditionPeriod": 5, "ConConditionPeriodType": "Years", "ValValuedByRef": 27, "ValDateValued": "2008-09-14", "ValNextDue": "2012-09-14", "ValReasonForValuation": "Insurance", "ValValuationPeriod": 4, "ValValuationPeriodType": "Years", "MulMultiMediaRef_tab": [ { "MulMultiMediaRef": 555 } ], "MulHasMultiMedia": "Y", "MulMultiMediaRefLocal": { "MulMultiMediaRefLocal_1": 555 }, "MulMediaPublishNoPasswordLocal": "Yes", "AdmGUIDPreferredType": "UUID4", "AdmGUIDPreferredValue": "5ffeb5cd-4edf-410a-9fff-5c6f67dc0056", "AdmGUIDIsPreferred_tab": [ { "AdmGUIDIsPreferred": "Yes" } ], "AdmGUIDType_tab": [ { "AdmGUIDType": "UUID4" } ], "AdmGUIDValue_tab": [ { "AdmGUIDValue": "5ffeb5cd-4edf-410a-9fff-5c6f67dc0056" } ], "AdmInsertedBy": "KE EMu Administrator", "AdmDateInserted": "2012-07-17", "AdmTimeInserted": "11:39:20.000", "AdmModifiedBy": "KE EMu Administrator", "AdmDateModified": "2025-08-05", "AdmTimeModified": "19:03:44.000", "AdmWebMetadata": "Tracking system console from Orroral Valley Tracking Station North America United States of America 1965 1965 1965 Glass Metal Plastic This is the tracking system console from Orroral Valley Tracking Station. It is a grey metal cabinet with a sloping desk section at front, featuring printed sheets bearing original satellite tracking coordinates beneath a perspex sheet. Switches and dials are located at the front for the operation of unit.", "AdmPublishWebNoPasswordFlag": "Y", "AdmPublishWebNoPassword": "Yes", "AdmPublishWebPasswordFlag": "Y", "AdmPublishWebPassword": "Yes", "SecCanDisplay_tab": [ { "SecCanDisplay": "Group Default" } ], "SecCanEdit_tab": [ { "SecCanEdit": "Group Default" } ], "SecCanDelete_tab": [ { "SecCanDelete": "Group Default" } ], "AccSourceRef_tab": [ { "AccSourceRef": 246 } ], "AccSourceRefLocal0": [ { "AccSourceRefLocal": { "AccSourceRefLocal_1": 246 } } ], "AccSourceLocal_tab": [ { "AccSourceLocal": "National Museum of Australia" } ], "ColCollectionEventRef": 7 } ]
`jsonql`	Produces JSON consistent with `texql` and its `describe` format. At each level the column name is given. Hence for tables each inner array contains an object with the inner column name. A JSON value is output for all items in the database, even empty ones. Example For example `texexport -l69 -fjsonql ecatalogue` in the museum environment will produce: [ { "irn": { "irn_1": 69 }, "SummaryData": "[Technology] \"Tracking system console from Orroral Valley Tracking Station\" [NM.2008.12]", "ExtendedData": "69\n[Technology] Object Accessioned\nTracking system console from Orroral Valley Tracking Station\nNM.2008.12, accessioned on\/in 2008", "ObjectType": "Object", "TitObjectStatus": "Accessioned", "TitObjectRating": "Medium", "TitObjectCategory": "Technology", "TitNumberOfParts": 1, "TitPartNumber": 1, "TitCollectionGroup_tab": [ { "TitCollectionGroup": null }, { "TitCollectionGroup": "Collection" }, { "TitCollectionGroup": null }, { "TitCollectionGroup": "Another Collection" } ], "TitAccessionNo": "NM.2008.12", "TitAccessionDate": "2008-09-28", "AccAccessionLotRef": 67, "AccAccessionLotRefLocal": { "AccAccessionLotRefLocal_1": 67 }, "TitPreviousAccessionNo_tab": [], "TitCreditLineLocal": "Source: National Museum of Australia", "TitRegisteredByRef": null, "TitRegistrationDate": null, "TitTransferType_tab": [], "TitTransferFromRef_tab": [], "TitTransferToRef_tab": [], "TitTransferDate0": [], "TitTransferNotes_tab": [], "TitOwnersNameRef_tab": [], "TitOwnersDates_tab": [], "TitOwnersStartDate0": [], "TitOwnersStartDateOrig_tab": [], "TitOwnersEndDate0": [], "TitOwnersEndDateOrig_tab": [], "TitOwnersNotes_tab": [], "CraCrateType": null, "CraOrientation": null, "CraCrateNumber": null, "CraNumberOfSlots": null, "CraTotalNumberOfTrays": null, "CraExternalHeight": null, "CraExternalDepth": null, "CraExternalWidth": null, "CraSlotHeight": null, "CraSlotDepth": null, "CraSlotWidth": null, "CraTrayHeight_tab": [], "CraTrayDepth_tab": [], "CraTrayWidth_tab": [], "CraRemarks_tab": [], "CraObjectsRef_tab": [], "FraType": null, "FraDescription": null, "FraTotalNoOfTrays": null, "FraAssociatedWorkRef": null, "FraAssociatedWorkRefLocal": null, "FraAssociatedWorkLocal": null, "FraExternalHeight": null, "FraExternalWidth": null, "FraExternalDepth": null, "FraInternalHeight": null, "FraInternalWidth": null, "FraInternalDepth": null, "FraGlazing": null, "FraBacking": null, "FraObjectsRef_tab": [], "TitMainTitle": "Tracking system console from Orroral Valley Tracking Station", "TitSeriesTitle": null, "TitCollectionTitle": null, "TitAlternateTitles_tab": [], "TitTitleNotes": null, "CreCreatorRef_tab": [], "CreRole_tab": [], "CreCreatorRefLocal0": [], "CreCreatorLocal_tab": [], "CreCreationPlace1_tab": [ { "CreCreationPlace1": "North America" } ], "CreCreationPlace2_tab": [ { "CreCreationPlace2": "United States of America" } ], "CreCreationPlace3_tab": [], "CreCreationPlace4_tab": [], "CreCreationPlace5_tab": [], "CreCreationPlaceSummary_tab": [], "CreDateCreated": "1965", "CreEarliestDate": "1965", "CreEarliestDateOrig": 0, "CreLatestDate": "1965", "CreLatestDateOrig": 0, "CreCreationNotes": null, "CreCulturalOrigin1": null, "CreCulturalOrigin2": null, "CreCulturalOrigin3": null, "CreCulturalOrigin4": null, "CreCulturalOrigin5": null, "CreCulturalOriginSummary": null, "CreSubjectClassification_tab": [], "CrePrimaryInscriptions": null, "CreOtherInscriptions": null, "CreProvenance": null, "EdiState": null, "EdiImpression": null, "EdiPublisherRef": null, "EdiEditionNotes": null, "EdiPatternNumber_tab": [], "EdiPatternNumberNotes_tab": [], "EdiBookNumberPages": null, "EdiBookPageNumbers": null, "PhyTechnique_tab": [], "PhyMedium_tab": [], "PhySupport": null, "PhyWatermark": null, "PhyMaterial_tab": [ { "PhyMaterial": "Glass" }, { "PhyMaterial": "Metal" }, { "PhyMaterial": "Plastic" } ], "PhyContentAnalysis_tab": [], "PhyDescription": "This is the tracking system console from Orroral Valley Tracking Station.\nIt is a grey metal cabinet with a sloping desk section at front, featuring printed sheets bearing original satellite tracking coordinates beneath a perspex sheet. Switches and dials are located at the front for the operation of unit.", "PhyPartPart_tab": [], "PhyPartAspect_tab": [], "PhyPartDescription0": [], "PhyHeight_tab": [ { "PhyHeight": 1095 } ], "PhyWidth_tab": [ { "PhyWidth": 1510 } ], "PhyDepth_tab": [ { "PhyDepth": 1150 } ], "PhyDiameter_tab": [], "PhyUnitLength_tab": [ { "PhyUnitLength": "mm" } ], "PhyWeight_tab": [], "PhyUnitWeight_tab": [], "PhyType_tab": [], "PhyVerbatimMeasurements": null, "AssIsParent": "Yes", "AssParentObjectRef": null, "AssRelatedObjectsRef_tab": [], "AssRelatedObjectsRelationship_tab": [], "AssRelatedObjectsRefLocal0": [], "AssRelatedObjectsLocal_tab": [], "AssOtherAssociationType_tab": [], "AssOtherAssociationNotes0": [], "AssRelatedPartiesRef_tab": [], "AssRelatedPartiesRelationship_tab": [], "AssRelatedEventsRef_tab": [], "AssRelatedEventsRelationship_tab": [], "AssRelatedPlacesLevel1_tab": [], "AssRelatedPlacesLevel2_tab": [], "AssRelatedPlacesLevel3_tab": [], "AssRelatedPlacesLevel4_tab": [], "AssRelatedPlacesLevel5_tab": [], "AssRelatedPlacesRelationship_tab": [], "AssRelatedPlacesSummary_tab": [], "RigRightsRef_tab": [], "RefCatalogueRaisonne": null, "BibBibliographyRef_tab": [], "RefBibliographicNotes_tab": [], "RefImageType_tab": [], "RefImageReference_tab": [], "RefFileTitle_tab": [], "RefFileReference_tab": [], "StaAuthorisedByRef_tab": [], "StaDateAuthorised0": [], "StaReason_tab": [], "StaStocktakeStatus": null, "StaStocktakeDate": null, "StaStocktakeByRef": null, "LocCurrentLocationRef": 1001690, "LocCurrentLocationRefLocal": { "LocCurrentLocationRefLocal_1": 1001690 }, "LocSummaryDataLocal": null, "LocRequestedByRef": 3, "LocReleasedByRef": 23, "LocAcceptedByRef": 23, "LocDateMoved": "2013-09-24", "LocTimeMoved": "11:29:", "LocIndependentlyMoveable": "Yes", "LocMovementNotes": null, "LocPermanentLocationRef": 1000051, "LocTemporaryLocationRef": null, "ConConditionStatus": "Excellent", "ConDateChecked": "2008-09-20", "ConCheckedByRef": 29, "ConNextCheck": "2013-09-20", "ConConditionPeriod": 5, "ConConditionPeriodType": "Years", "ConConditionDetails": null, "ConHandlingInstructions": null, "IllMaximumExposure": null, "IllExposurePeriod": null, "IllExposurePeriodType": null, "IllCumulativeExposure": null, "IllCumulativeStartDate": null, "IllCumulativeEndDate": null, "IllMaxDisplayableDays": null, "IllMaxDailyExposure": null, "IllMaxLuxLevel": null, "ConDispMinHumidity": null, "ConDispMaxHumidity": null, "ConDispGenHumidity": null, "ConDispMinCelTemperature": null, "ConDispMinFarTemperature": null, "ConDispMaxCelTemperature": null, "ConDispMaxFarTemperature": null, "ConDispGenTemperature": null, "ConDispMinLight": null, "ConDispMaxLight": null, "ConDispGenLight": null, "ConDispOtherInstructions": null, "DisExhibitionHistory": null, "ConStorMinHumidity": null, "ConStorMaxHumidity": null, "ConStorGenHumidity": null, "ConStorMinCelTemperature": null, "ConStorMinFarTemperature": null, "ConStorMaxCelTemperature": null, "ConStorMaxFarTemperature": null, "ConStorGenTemperature": null, "ConStorMinLight": null, "ConStorMaxLight": null, "ConStorGenLight": null, "ConStorOtherInstructions": null, "ValValuedByRef": 27, "ValDateValued": "2008-09-14", "ValValuationAmount": null, "ValValuationAmountOrig": null, "ValNextDue": "2012-09-14", "ValReasonForValuation": "Insurance", "ValValuationPeriod": 4, "ValValuationPeriodType": "Years", "ValValuationNotes": null, "InsInsuranceRef": null, "ValDepreciationCategory": null, "ValDepreciationDescription": null, "DeaDeaccessionMethod": null, "DeaAuthorisedByRef": null, "DeaDateAuthorised": null, "DeaMeetingTitle": null, "DeaMeetingDate": null, "DeaDeaccessionDate": null, "DeaDeaccessionNotes": null, "DeaReceivingPartyRef": null, "DeaTransferOfTitle": null, "DeaTransferDate": null, "DeaTransferNotes": null, "ColCollectionsRef_tab": [], "IsArchive": null, "ArchiveSortPosition": null, "AssParentObjectRefLocal": null, "EADParentIdentifierLocal": null, "EADTitleProper": null, "EADSubtitle": null, "EADSponsorRef": null, "EADEditionStatement": null, "EADPublicationStatement": null, "EADNoteStatement": null, "EADCreation": null, "EADLanguageOfFindingAid": null, "EADAuthorOfFindingAidRef": null, "EADLanguageCodeOfFindingAid": null, "EADDescriptiveRules": null, "EADRevisionDate": null, "EADRevision": null, "EADRevisionByRef": null, "EADRepositoryRef": null, "EADIdentifier": null, "EADUnitID": null, "EADComponentLevel": null, "EADLevelAttribute": null, "EADUnitTitle": null, "EADUnitDate": null, "EADUnitDateEarliest": null, "EADUnitDateEarliestOrig": null, "EADUnitDateLatest": null, "EADUnitDateLatestOrig": null, "EADOriginationRef_tab": [], "EADPreviousID_tab": [], "EADPhysicalDescription_tab": [], "EADExtent_tab": [], "EADDimensions": null, "EADGenreForm_tab": [], "EADPhysicalFacet": null, "EADMaterialSpecificDetail": null, "EADAbstract": null, "EADLanguageOfMaterial_tab": [], "EADLanguageCodeOfMaterial_tab": [], "EADBiographyOrHistory": null, "EADCustodialHistory": null, "EADAcquisitionInformationRef": null, "EADScopeAndContent": null, "EADAppraisalInformation": null, "EADAccessRestrictions": null, "EADUseRestrictions": null, "EADOtherFindingAid": null, "EADIndex": null, "EADAccruals": null, "EADArrangement": null, "EADFilePlan": null, "EADPhysicalTechnical": null, "EADProcessingInformation": null, "EADBibliographyRef_tab": [], "EADPreferredCitation": null, "EADOtherDescriptiveData": null, "EADNote": null, "EADLocationOfOriginals": null, "EADAlternativeFormAvailable": null, "EADRelatedMaterial": null, "EADSeparatedMaterial": null, "EADPersonalName_tab": [], "EADFamilyName_tab": [], "EADCorporateName_tab": [], "EADGeographicName_tab": [], "EADOtherName_tab": [], "EADSource": null, "EADName_tab": [], "EADPersonalNameRef_tab": [], "EADFamilyNameRef_tab": [], "EADCorporateNameRef_tab": [], "EADGeographicNameRef_tab": [], "EADSubjectAuthoritative_tab": [], "EADFunction_tab": [], "EADOccupation_tab": [], "EADSubject_tab": [], "EADTitle_tab": [], "AcnAccessionLotRef_tab": [], "AcnLocationRef_tab": [], "AcnOriginalExtent_tab": [], "AcnAssessmentType_tab": [], "AcnAssessmentValue_tab": [], "AcnConservationNeeds": null, "AcnDescription": null, "AcnProcessingPlan": null, "TitAcquisitionMethod": null, "TitFullName": null, "MulMultiMediaRef_tab": [ { "MulMultiMediaRef": 555 } ], "MulHasMultiMedia": "Y", "MulMultiMediaRefLocal": { "MulMultiMediaRefLocal_1": 555 }, "MulMediaPublishNoPasswordLocal": "Yes", "NotNotes": null, "AdmGUIDPreferredType": "UUID4", "AdmGUIDPreferredValue": "5ffeb5cd-4edf-410a-9fff-5c6f67dc0056", "AdmGUIDIsPreferred_tab": [ { "AdmGUIDIsPreferred": "Yes" } ], "AdmGUIDType_tab": [ { "AdmGUIDType": "UUID4" } ], "AdmGUIDValue_tab": [ { "AdmGUIDValue": "5ffeb5cd-4edf-410a-9fff-5c6f67dc0056" } ], "AdmInsertedBy": "KE EMu Administrator", "AdmDateInserted": "2012-07-17", "AdmImportIdentifier": null, "AdmTimeInserted": "11:39:20.000", "AdmSystemIdentifier": null, "AdmModifiedBy": "KE EMu Administrator", "AdmDateModified": "2025-08-05", "AdmTimeModified": "19:03:44.000", "AdmWebMetadata": "Tracking system console from Orroral Valley Tracking Station North America United States of America 1965 1965 1965 Glass Metal Plastic This is the tracking system console from Orroral Valley Tracking Station. It is a grey metal cabinet with a sloping desk section at front, featuring printed sheets bearing original satellite tracking coordinates beneath a perspex sheet. Switches and dials are located at the front for the operation of unit.", "AdmPublishWebNoPasswordFlag": "Y", "AdmPublishWebNoPassword": "Yes", "AdmPublishWebPasswordFlag": "Y", "AdmPublishWebPassword": "Yes", "AdmOriginalData": null, "SecRecordStatus": null, "SecWebImportance": null, "SecCanDisplay_tab": [ { "SecCanDisplay": "Group Default" } ], "SecCanEdit_tab": [ { "SecCanEdit": "Group Default" } ], "SecCanDelete_tab": [ { "SecCanDelete": "Group Default" } ], "SecDepartment_tab": [], "TasDescription_tab": [], "TasResults_tab": [], "TasPersonAssignedToRef_nesttab": [], "TasDependOnTask_tab": [], "TasDependOnCompletionOffset_tab": [], "TasTaskDuration_tab": [], "TasCommenceNotifyOffset_tab": [], "TasCompletionNotifyOffset_tab": [], "TasDependOnPosition_tab": [], "TasCommenceNotifyRef_nesttab": [], "TasCompletionNotifyRef_nesttab": [], "TasTaskAssignerRef_tab": [], "TasCommencementDate0": [], "TasStartNotifyDate0": [], "TasTimeTakenOnTask_tab": [], "TasCompleted_tab": [], "TasCompletionDate0": [], "TasEndNotifyDate0": [], "TaxTaxonomyRef_tab": [], "IdeIdentifiedByRef_nesttab": [], "IdeFiledAs_tab": [], "IdeDateIdentified0": [], "IdeIdentificationNotes0": [], "IdeCurrentTaxonRef": null, "IdeCurrentTaxonRefLocal": null, "IdeCurrentScientificNameLocal": null, "IdeCommonNameLocal": null, "IdeCurrentIdentifiedByRef": null, "IdeCurrentIdentifiedByRefLocal": null, "IdeCurrentIdentifiedByLocal": null, "SitPreciseLocation_tab": [], "ColCollectorsRef_tab": [], "ColCollectionNotes_tab": [], "ColCollectionDates0": [], "ColCollectorsRefLocal0": [], "ColCollectorsLocal_tab": [], "ColCollectionType": null, "ColCollectionMethod": null, "ColRecordedUse": null, "AccSourceRef_tab": [ { "AccSourceRef": 246 } ], "AccSourceRefLocal0": [ { "AccSourceRefLocal": { "AccSourceRefLocal_1": 246 } } ], "AccSourceRoleRef_tab": [], "AccSourceLocal_tab": [ { "AccSourceLocal": "National Museum of Australia" } ], "SpeNumberSpecimens": null, "SpeNumberMale": null, "SpeNumberFemale": null, "SpeAge": null, "SpePhase": null, "SpeForm": null, "SpeVariety": null, "SpeMedium": null, "ColCataloguerRef_tab": [], "SpePreparation_tab": [], "SpePreparedByRef_tab": [], "SpePreparationNotes_tab": [], "ColCataloguerDate0": [], "SpeDatePrepared0": [], "MapTitle": null, "MapAbbreviatedTitle": null, "MapScale": null, "MapAuthorsRef_tab": [], "MapRole_tab": [], "MapEdition": null, "MapVolume": null, "MapPages": null, "MapPublisherRef": null, "MapPublicationDate": null, "MapPublicationCity": null, "MapSeriesTitle": null, "MapSeriesVolumeRange": null, "MapSeriesDateRange": null, "GeoIdentifiedByRef_tab": [], "GeoClass": null, "GeoGroup": null, "GeoName": null, "GeoVariety": null, "GeoChronostratigraphy": null, "GeoLithostratigraphy": null, "ImaNegativeNumber": null, "ImaImageType": null, "ImaImageSize": null, "ImaImageDescription": null, "SitSiteCode_tab": [], "SitProjectName_tab": [], "SitSiteCharacter_tab": [], "SitMonumentType_tab": [], "SitSiteName_tab": [], "SitInterventionRef_tab": [], "SitArchaeoFeatures": null, "SitBulkFindType_tab": [], "SitBulkFindLocationRef_tab": [], "SitBulkFindQuantity_tab": [], "SitBulkFindQuantityType_tab": [], "SitPaperArchiveType_tab": [], "SitPaperArchiveLocationRef_tab": [], "SitPaperArchiveQuantity_tab": [], "SitPaperArchiveQuantityType_tab": [], "SitLegacyArchives_tab": [], "SitLegacyArchivesLocationRef_tab": [], "SitLegacyArchivesQuantity_tab": [], "ClaObjectName_tab": [], "EthLocalName": null, "ColCollectionEventRef": 7, "ColDateCollectedFrom": null, "ColDateCollectedTo": null, "EthLanguageGroup": null, "EthCulturalGroup": null, "EthAssociatedDeity_tab": [], "ColCollectorsRole_tab": [], "ClaLevel1Classification": null, "ClaLevel2Classification": null, "ClaLevel3Classification": null, "ClaLevel4Classification": null, "ClaLevel5Classification": null, "ClaActivityCode_tab": [], "AssAssociationsType_tab": [], "AssAssociationNameRef_tab": [], "AssSiteRef_tab": [], "AssPreciseLocation_tab": [], "AssSiteRefLocal": null, "AssSiteSummaryDataLocal": null, "AssSiteRefLocal0": [], "SiteContinentLocal_tab": [], "SiteCountryLocal_tab": [], "SiteProvinceStateTerritoryLocal_tab": [], "SiteDistrictCountyShireLocal_tab": [], "SiteTownshipLocal_tab": [], "AssAssociationDate_tab": [], "AssAssociationEarliestDateOrig_tab": [], "AssAssociationLatestDateOrig_tab": [], "AssAssociationEarliestDate0": [], "AssAssociationLatestDate0": [], "AssAssociationEvent_tab": [], "AssAssociationPeriod_tab": [], "AssAssociationComments0": [], "NteText0": [], "NteAttributedToRef_nesttab": [], "NteBibliographyRef_nesttab": [], "NteDate0": [], "NteType_tab": [], "SecLookupRoot": null, "Validation": null } ]
`jsonqlbrief`	As for `jsonql` format except empty items are skipped. Example For example `texexport -l69 -fjsonbrief ecatalogue` in the museum environment will produce: [ { "irn": 69, "SummaryData": "[Technology] \"Tracking system console from Orroral Valley Tracking Station\" [NM.2008.12]", "ExtendedData": "69\n[Technology] Object Accessioned\nTracking system console from Orroral Valley Tracking Station\nNM.2008.12, accessioned on\/in 2008", "ObjectType": "Object", "TitObjectStatus": "Accessioned", "TitObjectRating": "Medium", "TitObjectCategory": "Technology", "TitNumberOfParts": 1, "TitPartNumber": 1, "TitCollectionGroup": [ null, "Collection", null, "Another Collection" ], "TitAccessionNo": "NM.2008.12", "TitAccessionDate": "2008-09-28", "AccAccessionLotRef": 67, "AccAccessionLotRefLocal": 67, "TitCreditLineLocal": "Source: National Museum of Australia", "TitMainTitle": "Tracking system console from Orroral Valley Tracking Station", "CreCreationPlace1": [ "North America" ], "CreCreationPlace2": [ "United States of America" ], "CreDateCreated": "1965", "CreEarliestDate": "1965", "CreEarliestDateOrig": 0, "CreLatestDate": "1965", "CreLatestDateOrig": 0, "PhyMaterial": [ "Glass", "Metal", "Plastic" ], "PhyDescription": "This is the tracking system console from Orroral Valley Tracking Station.\nIt is a grey metal cabinet with a sloping desk section at front, featuring printed sheets bearing original satellite tracking coordinates beneath a perspex sheet. Switches and dials are located at the front for the operation of unit.", "PhyHeight": [ 1095 ], "PhyWidth": [ 1510 ], "PhyDepth": [ 1150 ], "PhyUnitLength": [ "mm" ], "AssIsParent": "Yes", "LocCurrentLocationRef": 1001690, "LocCurrentLocationRefLocal": 1001690, "LocRequestedByRef": 3, "LocReleasedByRef": 23, "LocAcceptedByRef": 23, "LocDateMoved": "2013-09-24", "LocTimeMoved": "11:29:", "LocIndependentlyMoveable": "Yes", "LocPermanentLocationRef": 1000051, "ConConditionStatus": "Excellent", "ConDateChecked": "2008-09-20", "ConCheckedByRef": 29, "ConNextCheck": "2013-09-20", "ConConditionPeriod": 5, "ConConditionPeriodType": "Years", "ValValuedByRef": 27, "ValDateValued": "2008-09-14", "ValNextDue": "2012-09-14", "ValReasonForValuation": "Insurance", "ValValuationPeriod": 4, "ValValuationPeriodType": "Years", "MulMultiMediaRef": [ 555 ], "MulHasMultiMedia": "Y", "MulMultiMediaRefLocal": 555, "MulMediaPublishNoPasswordLocal": "Yes", "AdmGUIDPreferredType": "UUID4", "AdmGUIDPreferredValue": "5ffeb5cd-4edf-410a-9fff-5c6f67dc0056", "AdmGUIDIsPreferred": [ "Yes" ], "AdmGUIDType": [ "UUID4" ], "AdmGUIDValue": [ "5ffeb5cd-4edf-410a-9fff-5c6f67dc0056" ], "AdmInsertedBy": "KE EMu Administrator", "AdmDateInserted": "2012-07-17", "AdmTimeInserted": "11:39:20.000", "AdmModifiedBy": "KE EMu Administrator", "AdmDateModified": "2025-08-05", "AdmTimeModified": "19:03:44.000", "AdmWebMetadata": "Tracking system console from Orroral Valley Tracking Station North America United States of America 1965 1965 1965 Glass Metal Plastic This is the tracking system console from Orroral Valley Tracking Station. It is a grey metal cabinet with a sloping desk section at front, featuring printed sheets bearing original satellite tracking coordinates beneath a perspex sheet. Switches and dials are located at the front for the operation of unit.", "AdmPublishWebNoPasswordFlag": "Y", "AdmPublishWebNoPassword": "Yes", "AdmPublishWebPasswordFlag": "Y", "AdmPublishWebPassword": "Yes", "SecCanDisplay": [ "Group Default" ], "SecCanEdit": [ "Group Default" ], "SecCanDelete": [ "Group Default" ], "AccSourceRef": [ 246 ], "AccSourceRefLocal0": [ 246 ], "AccSourceLocal": [ "National Museum of Australia" ], "ColCollectionEventRef": 7 } ]

texeport: JSON export formats

`texeport`: JSON export formats